Custom Target Schema
This option applies to the following targets: SQL Server, SQL Server Azure, PostgreSQL, SAP HANA, DB2, Redshift, and Snowflake.
Unless you specify otherwise, Pyramid will connect to the database's default schema. You can set a custom schema by clicking the Set Schema button from the Target Tables window.
From the Custom Target Schema dialog, enter the required target schema.
You can also set a custom output schema for a given column in the Target Tables window.